package com.softer.wxzj.mapper;

import com.softer.wxzj.entity.BaseCellInfo;
import com.softer.wxzj.entity.BaseHouseInfo;
import com.softer.wxzj.entity.ExpProjectReqDetail;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ExpProjectReqDetailMapper {
    int deleteByPrimaryKey(String id);

    int insert(ExpProjectReqDetail record);

    int insertSelective(ExpProjectReqDetail record);

    ExpProjectReqDetail selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(ExpProjectReqDetail record);

    int updateByPrimaryKey(ExpProjectReqDetail record);

    List<ExpProjectReqDetail> GetInfoByReqId(String reqId);

    /**
     * 通过reqId查询数据通过自然幢汇总rooms
     *
     * @param reqId
     * @return
     */
    List<ExpProjectReqDetail> selectForPayReqIdByRooms(String reqId);

    /**
     * @param allHouse
     * @return
     */
    BaseCellInfo selectByHouseAndExp(String allHouse);

    /**
     * 房屋有没有在使用
     * @param roomNo
     * @return
     */
    int expCountHouse(String roomNo);
}
